Header Segergation

Question

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.

BeforeAccountNoTaxYearCusipNoAmountNRATaxWithdb49.9NRATr101120230101202312312023    XXXXXXXXXXXXXXXXXXXXXXXXX00000.000.00     AfterAccountNoTaxYearCusipNoAmountNRATaxWithdb49.9NRATr  101120230101202312312023 XXXXXXXXXXXXXXXXXXXXXXXXX00000.000.00

Any help would be appriciated.

Thanks,,

Raj · Answer

PFA,

Hope this help

New Workflow673.yxmd

Myusrename001 · Answer

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

caltang · Answer

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.