Changing the Column Header

[gogokevin13]

Hi  Experts, 

I have a txt file that is in the format as below. 

     Trade Name Date CurrencyAmount

1   XXXXDDMMYYUSD-YYYYY

2  XXXXDDMMYYUSD-YYYYY

3  XXXXDDMMYYUSD-YYYYY

and so forth. 

First I want to split the headers in to appropriate delimiters, in this case

TradeName  Date  Currency  Amount

In addition I want to delimit the datasets but there are no spaces in between. The only delimiter present is the - between the currency and the amount. Can you please help me to place the correct dataset in the correct column. Thank you very much in advance. 

[Qiu]

@gogokevin13 

Can you provide a sample dataset so we can understand your data format for parsing.

[gogokevin13]

Thank you for your reply.

I cannot provide the direct txt file. However the table is as below in Alteryx. 

[Qiu · Accepted solution]

@gogokevin13 

For the dataset, we can parse like this.

But for the header, it will be very challenging since there is obvious pattern there.

Do you allow manully naming columns?