1 Topic by kbalmer

  • kbalmer
  • Veteran
  • Offline
  • From: Bedford
  • Registered: 12-05-2006
  • Posts: 162

Topic: Import wizard - Observer names concatenated by ampersand

In excel I usually concatenate multiple columns of observers together into one for importing using ampersand.
e.g. 

=G2 & " & " & H2

However, in the initial data grid of the import wizard this is now coming through as "&" (i.e. the HTML equivalent) and I'm then being presented with "amp" as an observer name to match. e.g. 

In excel:
 M.Mouse & D.Duck    

In import wizard grid     
 M.Mouse & D.Duck 

In observer list
amp
D.Duck
M.Mouse

We are using 6.24.0.280 and dictionary 3B so I think we are up-to-date.

It's not a show-stopper as I've replaced ampersand with comma and I can import without problems, but I thought it odd that it has suddenly started to do this.

Keith

kbalmer's Website

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Import wizard - Observer names concatenated by ampersand

Thanks. Could be something to do with the change made to the parsing. I will check it out.

Mike Weideli

MikeWeideli's Website