Question

Removing Comma from CSV within External File Template

  • 20 February 2024
  • 1 reply
  • 47 views
unite45
Rank
Badge +1

Looking for a bit of guidance here, my company is utilizing External File Template to upload our travel expenses made with company credit cards to the Credit Card Transactions in Aurena. Recently, we’ve come across a few transactions that contain a comma in them, which creates an error when trying to upload via External File Assistant. I would like to accomplish this using a Detail function for the column. 

I’ve included the problem transaction for reference - 

Cleared,1/3/2024,"ONLINE PAYMENT, THANK YOU",-500

Error we’re getting - 

 

Would like to remove or skip comma from string utilizing one of these - 

 

I would appreciate any help or guidance on this. 

1 reply

F
Rank
Userlevel 6
Badge +19

Hello @unite45 

As long as you have double quotes around your text there should not be problem with importing the date in case of your column separator is in somewhere in the text. I cant see your column separator from the screen shot but I assume that it is comma. In this case the row below should not create any problem

Cleared,1/3/2024,"ONLINE PAYMENT, THANK YOU",-500

 

Anyway, have you tried using REPLACE function? In function argument use below code. Basically it will remove comma from the text. You need to use this for the column where you store "ONLINE PAYMENT, THANK YOU" information.

COLUMN_REF,",",""

 

Hope this helps

https://superp.solutions/

Reply


Terms & ConditionsCookie settings