ETL and Data Integration tools - Modern ETL software for everyone

I have an import question. I have a field named [F2] being loaded in it's pure form into a column on a table.
The format looks like '415097400', it's a text field.
I want to take that field and load it into another column with a space after the 2nd byte, so it would look like '41 5097400'.
I've tried it using the substring function and couldn't get it working.
Can you tell me what format I should use to accomplish this?

Ron

Ron

You can use combination of let and right functions plus joiner

Very easy

Mike