4 Replies Latest reply on Dec 9, 2016 8:06 AM by Michael Hesser

    How to load fixed record data in Tableau

    archana.chandra
      1020833801001009415200032016055A2016224MG  2016061A2016224966AEN 00  A                                        WEST          CHERYL     L   37 WESTVIEW DR                                      MC SHERRYSTOWN  PA173441322 
      1020833801001009415200032016055A2016224MG  2016061A2016224966AEN 00  A                                        WEST          CHERYL     L   37 WESTVIEW DR                                      MC SHERRYSTOWN  PA173441322 
      1020833801001009415200032016055A2016224MG  2016061A2016224966AEN 00  A                                        WEST          CHERYL     L   37 WESTVIEW DR                                      MC SHERRYSTOWN  PA173441322 
      1020833801001009415200032016055A2016224MG  2016061A2016224966AEN 00  A                                        WEST          CHERYL     L   37 WESTVIEW DR                                      MC SHERRYSTOWN  PA173441322 

       

       

      I have  following data in CSV file. All the data is in one column. I need to create fields based on character position . e.g

       

        @2:8 as [A]

           @9:10 as [B],

           @11:11 as [C],

           @12:20 as [D],

           @21:24 as [E],

           @25:31 as [F],

           @32:32 as [G],

         

           @40:43 as [H],

           @44:50 as [I],

           @51:51 as [J] ,

           @70:70 as [L]

       

       

      Any help will be highly  Appreciated!!