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 

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?

0128-gogokevin13.yxmd