I have this script:
#!/bin/bash
echo Id,Name,Amount,TS > lfs.csv
I want to insert values that will match the columns I created (as above in the script) , I want for example to insert: 56,"Danny",579,311413567 I want to be able to insert it using 'FOR' loop which will insert values without stopping but to change the values for each insert
More detail would be useful what you like to achieve exactly, so I made a infinite for loop which put line into the csv incremented numbers you provide by $i. ( I cannot make comment yet to ask you )
Update: I still using a infinite loop to get a number counting up to the endless, and using a variable (u_id) to count from 1 to 100 then reset it back to 1 if it is reach 100.
#!/bin/bash
echo 'Id,Name,Amount,TS,unique_ID' > lfs.csv
u_id=0
for (( id=1 ; ;id++ ))
do
[[ $u_id == 100 ]] && (( u_id = 1 )) || (( u_id +=1 ))
echo $id",Danny_"$id","$id","$id","$u_id >> lfs.csv
done
If you like to start Amount and TS from bigger number you can do that by modifing $id to $(( id + 50000 )) like:
echo $id",Danny_"$id","$(( id + 300 ))","$(( id + 50000 ))","$u_id >> lfs.csv
