Solved

Migration many rows on one column

  • 16 March 2021
  • 3 replies
  • 315 views
O
Rank
Userlevel 2
Badge +4

Dear All Member

 

I try to migration data on Sales Quotation page but .csv file as following I can’t do it.

Because when I upload .csv file on Execute job that can't keep store on one row.

 

on my csv, I have data 3 rows on one column.

on Execute Job when I upload, it will split line by itself.

 

If manual input on Sales Quotation page, It can show many rows on Quotation Notes.

I need to migration data many rows on  one column only like below image. 

How can migration job when it has many rows on one column ?

page: Sales Quotation > Misc Quatation Info 

 

icon

Best answer by dhlelk 16 March 2021, 04:29

View original

3 replies

dhlelk
Rank
Userlevel 6
Badge +15

Hi @Onjira,

CSV files doesn't support line breaks, you could check this by opening the .csv file from notepad.
Hence you could use a workaround to replace the new line character with a placeholder text like "#NEW_LINE#" when uploading and then replace it back to the new line character when migrating data to the source columns.

Check this link for steps on how to find and replace the new line character in excel.

Thereafter you could replace the placeholder text "#NEW_LINE#" back to the new line character on your source migration job.
REPLACE(<YOUR_COLUMN_NAME_HERE>, '#NEW_LINE#', CHR(13) || CHR(10))

Cheers !
Dhananjaya.

https://www.linkedin.com/in/kludl/
O
Rank
Userlevel 2
Badge +4

Hello, Dhananjaya

 

Thank you for your helping!

I can do it with your advice. It’s worked!!!

 

Regards,

Onjira

dhlelk
Rank
Userlevel 6
Badge +15

Hello, Dhananjaya

 

Thank you for your helping!

I can do it with your advice. It’s worked!!!

 

Regards,

Onjira

Hi @Onjira,

You are welcome and I'm happy to help 😊

Cheers !
Dhananjaya.

https://www.linkedin.com/in/kludl/

Reply


Terms & ConditionsCookie settings