Skip to content

Column spin file doesn't follow normal CSV formatting

Hi @Sven,

Just a quick one - I was using %column-spinfile% with a standard csv file as saved by excel. One of the text fields had commas in it, and as usual was wrapped in "quotes". Most CSV parsers will ignore the commas within the quotes as it is a text field, but GSA sees the following:

col1: "Word
col2: and another
col3: word"

instead of
col1: "Word, and another, word"

It would be handy if we could use text colums in csvs without worrying too much about formatting. Thanks!

Comments

  • SvenSven www.GSA-Online.de
    next version will follow the rules here more closely.
  • That's brilliant, thanks sven !
  • Also, while you're in the spinfile neighbourhood I noticed this little issue when my URL is loaded from a columnspinfile:

    Anchor_Text
    rankings2.csv-3
     -> Anchor text taken from domain anchor

    ie: if you are using domain anchor it looks like it is truncating the url before it is loaded from the macro rather than after, so you sometimes get a fragment of the macro rather than of the domain name. Using %url% in another anchor field works as expected, so that's what I'm using fo rnow.
  • SvenSven www.GSA-Online.de
    sorry I don't understand what you try to do here.
Sign In or Register to comment.