Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

importing csv to database with colons and breaklines : in it

Y

yourfriendkarol last edited by

I can export>import records because colons and linebreaks ruin it when I import it. im getting data in wrong tables etc

how to prevent?

To specify more, I have colons and linebreaks in columns, for example one column is URL and other is ARTICLE with colons or/and linebreaks
Reply Quote 1
1 Reply Last reply
S

spa3212 last edited by spa3212

I am also having the same problem, can anyone help?
Reply Quote 0
1 Reply Last reply

2
Posts

377
Views

Log in to reply

Y

change database location?
Support • • yourfriendkarol

1

1
Votes

1
Posts

381
Views

No one has replied
Y

Is File Resource More Computer-Heavy Task Than Database-Resource?
Support • • yourfriendkarol

1

0
Votes

1
Posts

98
Views

No one has replied
G

"à" "é" "ê" not supported when import from lines is used
Support • • GGMA

1

0
Votes

1
Posts

215
Views

No one has replied
Y

Database forgots often which group to post to
Support • • yourfriendkarol

1

0
Votes

1
Posts

283
Views

No one has replied
Z

Correct way to loop through all entries of a database resource?
Support • • zw

5

0
Votes

5
Posts

919
Views

@andy231 said in Correct way to loop through all entries of a database resource?: линию в цикле или на запуск потока и отключить ресурс повторного использования, чтобы каждый раз, когд How about limiting the number of elements in the resource?
D

How to import an URL from csv
Support • • Demandas

2

0
Votes

2
Posts

17
Views

G

Use resources to import csv file into BAS. Define resource type as "Lines from file" and set it to "Use each line one time" if you need that behavior. Than just put resource variable in place of URL.
Interface Api.DatabaseUpdate --> Database Error
Support • • Allister

2

1
Votes

2
Posts

381
Views

@allister Hi, this is bug, it happens only if update column of int type. It was fixed, new version will be available in Thursday(8 November), if it is urgent for you, I can make a separate build.
H

Search the whole of database table for a string
Support • • HELP_ME

2

0
Votes

2
Posts

105
Views

@HELP_ME said in Search the whole of database table for a string: Hi, I have seen this https://community.bablosoft.com/topic/3750/how-to-avoid-duplicates-in-database/3 and want to know if its possible to search the whole of the database table for a string. I have tried what the OP has tried, list functions such as get index and list contains aren't working as expected, it doesn't let you search the whole database for a string(it returns false / no result) nor select records by criteria. Use the filter in the "Select Records By Criteria" action

1 / 1