Merge and format data after loading

[maxsugak]

Hi!

I'm loading data in Sense using  basic script and have 2 issues:

1. I need to merge columns. For example in Excel it looks like "ABC" and "DEF" columns, and after loading I need the only column "ABCDEF".  I'm trying to do the next:

LOAD
Column1 & Column2 as Column3

But I get double data in a table like this "ABCDEFDEF".  Could anyboby explain me my mistake?

2. After loading I need to delete some special symbols in a string. For example make "ABC!!DEF" to "ABCDEF" removing those exclamation marks. 

Any suggestions please? 

[prieper]

wrong group - should be QS.
for 1. please post an example. If content in Column1 is "ABC" and in Column2 "DEF" then the result of Column1 & Column2 should be "ABCDEF".
You may use REPLACE, e.g.
REPLACE(MyString, '!', '')
or load only characters with
KEEPCHAR(MyString, 'abcdefgh.....ABCDEFG...1234567890')

HTH Peter

[uacg0009 · Accepted solution]

Hi Maxsugak,

For the first one:

I think normally you will get "ABCDEF" value in column3, if possible, it's better to share a small sample of your data, so I can check the reason that why you get "ABCDEFDEF" in column3.

For the second question:

You can use PurgeChar() function, in your example, like : = PurgeChar(Column3,'!')

Aiolos Zhao

[maxsugak]

Thanks a lot!

I will try to fix it on my own firstly. Such a challange 🙂
I just wanted to make sure I use correct operator ... & ... as ....

Thanks!

[maxsugak]

Sorry about the group, my fault.
Thansk for your reply!