Header Segergation

[Myusrename001]

Hello Team,

Below is the Schema reference i need to convert the 1st line and break into 2 section i.e reference "db49.9NRATr" Under "AccountNo"  and "101120230101202312312023" under amount column which has 24 characters. 

I cannot do formatting becuase the schema size for amount is restricted to 16 characters on line 2 and the 1 line has 24 character, is there any way to segergate the first line only and without effecting the schema on the second line. 

Before
AccountNo	TaxYear	CusipNo	Amount	NRATaxWith
db49.9NRATr101120230101202312312023
XXXXXXXXXXXXX	XXXX	XXXXXXXX	00000.00	0.00
After
AccountNo	TaxYear	CusipNo	Amount	NRATaxWith
db49.9NRATr			101120230101202312312023
XXXXXXXXXXXXX	XXXX	XXXXXXXX	00000.00	0.00

Any help would be appriciated.

Thanks,,

[caltang]

Please provide relevant data to this use case, and kindly provide your criteria in as much detail as possible. If you have a workflow built halfway, kindly export that over as well.To export a workflow go to: Options > Export Workflow. Kindly do NOT send a "Save As" copy.

[Myusrename001]

@caltang Thanks for your feedback - I have utilized left and substring function to process the 1st line. 

[Raj]

PFA,

Hope this help