Jump to content

item_db.txt and item_db2.txt converter to excel


Recommended Posts


  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  29
  • Reputation:   2
  • Joined:  05/01/12
  • Last Seen:  

Hello mga kaibigan!..Share ko lang tong nagawa kong simpleng c program para sa pag convert ng item_db.txt tsaka item_db2.txt files to excel files..try nyo lang po if magustuhan nyo..nagawa ko to dahil sa aking pagiging OC..lol

txt2xls-v1.0.rar

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  554
  • Reputation:   70
  • Joined:  04/04/12
  • Last Seen:  

hmm..tanung ko lang kung anung pinagkaiba nito sa import/export ng ms office(excel)???

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  29
  • Reputation:   2
  • Joined:  05/01/12
  • Last Seen:  

hmm..tanung ko lang kung anung pinagkaiba nito sa import/export ng ms office(excel)???

una, tinanggal ung mga commas na nakapagitan sa mga codes at pinasok isa-isa sa cells ng excel..pangalawa, ang import kasi, sinisave line per line ang mga nasa text file sa isang column (specifically, column 1) lang..eto, nakadistribute evenly sa mga cells..

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  554
  • Reputation:   70
  • Joined:  04/04/12
  • Last Seen:  

hmm.. :)

diba pwede mo naman iset sa import kung anung delimiter ang gagamitin...??

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  29
  • Reputation:   2
  • Joined:  05/01/12
  • Last Seen:  

hmm.. :)

diba pwede mo naman iset sa import kung anung delimiter ang gagamitin...??

opo tama po kayo..pero nagkakaproblema po kasi pagdating po sa script {}..possible di ba po ung multi-bonuses sa scripts?..kaya pag gagamitin ung pagtanggal ng comma delimiter sa excel, nasasama ung sa scripts..tsaka isa pa po, one click lang ung program na to kaya convenient..:D

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  554
  • Reputation:   70
  • Joined:  04/04/12
  • Last Seen:  

hmmm..ahh...ok...^^,

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  38
  • Topics Per Day:  0.01
  • Content Count:  109
  • Reputation:   0
  • Joined:  12/27/11
  • Last Seen:  

May I ask? Kaya rin ba nitong I import to item_db.txt yung sa excel?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  9
  • Topics Per Day:  0.00
  • Content Count:  268
  • Reputation:   27
  • Joined:  12/06/11
  • Last Seen:  

Ang pinaka madali nito is just change the file type from .txt to .csv viola! It can be opened by Excel and separated yung values by cell instead na by comma. /no1

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...