Need a re-usable function that will scan the headers in a csv file and
1) Find the text that is passed in
2) Scan all rows in the column and split the data into a new column if character limit is more than 245 characters
3) Name the new column “header text” _1
4) Insert New Columns until _4 is reached

All inserted columns should be directly to the right of the previous column. As an example, if the header text we are scanning for is “Marcus”, we would find the column in the csv with the header text “Marcus” – scan each row in the column, if the character llimit is more than 245 characters insert a new column to the right of this column with the header text “Marcus_1” and paste the remaning chracters. Then we will insert new columns for “Marcus_2”, “Marcus_3”, “Marcus_4”

Share the Post:

Related Posts